from sqlalchemy import Column, Integer, String
from backend.library.database import Base

class Signin(Base):

    __tablename__ = 'signin'

    id = Column(Integer, primary_key=True, autoincrement=True, comment="ID" )
    
    location = Column(String(100), comment="上课地点")
    course_name = Column(String(200), comment="课程名称, course表冗余字段") 
    teacher_id = Column(Integer,  comment="任课教师, course表冗余字段")
    teacher_name = Column(String(100), comment="教师姓名, course表冗余字段")
    class_name = Column(String(100), comment="上课班级, course表冗余字段")
    term = Column(String(100), comment="开设学期, course表冗余字段")
    lng = Column(String(20), comment="打卡经度")
    lat = Column(String(20), comment="打卡纬度")
    status = Column(Integer,  comment="签到状态 0 未打开，1 正常，2 异常，3 迟到，4 补卡")
